﻿using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DFGK_WMS.Model.Models
{
    /// <summary>
    /// 西安物料数据表
    /// </summary>
    public class Conf_material
    {
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.None)]
        public int Id { get; set; }

        /// <summary>
        /// 物料编码
        /// </summary>
        [MaxLength(64)]
        public string Material_no { get; set; }

        /// <summary>
        /// 物料描述
        /// </summary>
        [MaxLength(255)]
        public string Material_desc { get; set; }

        /// <summary>
        /// 物料类型
        /// </summary>
        [MaxLength(128)]
        public string Material_type { get; set; }

        /// <summary>
        /// 工厂级物料删除标识
        /// </summary>
        [MaxLength(255)]
        public string Del_mark_factory { get; set; }

        /// <summary>
        /// 删除标识
        /// </summary>
        [MaxLength(16)]
        public string Del_mark { get; set; }

        /// <summary>
        /// 单位
        /// </summary>
        [MaxLength(16)]
        public string Material_unit { get; set; }

        /// <summary>
        /// 物料组
        /// </summary>
        [MaxLength(128)]
        public string Material_group { get; set; }

        /// <summary>
        /// 物料组描述
        /// </summary>
        [MaxLength(255)]
        public string Group_desc { get; set; }

        /// <summary>
        /// 长度
        /// </summary>
        [Column(TypeName = "decimal(18,2)")]
        public decimal? Length { get; set; }

        /// <summary>
        /// 宽度
        /// </summary>
        [Column(TypeName = "decimal(18,2)")]
        public decimal? Width { get; set; }

        /// <summary>
        /// 高度
        /// </summary>
        [Column(TypeName = "decimal(18,2)")]
        public decimal? Weight { get; set; }

        /// <summary>
        /// 长/宽/高单位
        /// </summary>
        [MaxLength(16)]
        public string Unit { get; set; }

        /// <summary>
        /// 毛重
        /// </summary>
        [Column(TypeName = "decimal(18,2)")]
        public decimal? Rough_weight { get; set; }

        /// <summary>
        /// 净重
        /// </summary>
        [Column(TypeName = "decimal(18,2)")]
        public decimal? Net_weight { get; set; }

        /// <summary>
        /// 重量的单位
        /// </summary>
        [MaxLength(16)]
        public string Weight_unit { get; set; }

        /// <summary>
        /// 体积
        /// </summary>
        [Column(TypeName = "decimal(18,2)")]
        public decimal? Volume { get; set; }

        /// <summary>
        /// 体积的单位
        /// </summary>
        [MaxLength(16)]
        public string Volume_unit { get; set; }

        /// <summary>
        /// 保质期
        /// </summary>
        [MaxLength(16)]
        public string Shelf_life { get; set; }

        /// <summary>
        /// 危险物料标识
        /// </summary>
        [MaxLength(16)]
        public string Risk_mark { get; set; }

        /// <summary>
        /// 批次特性分类
        /// </summary>
        [MaxLength(64)]
        public string Batch_properties { get; set; }

        /// <summary>
        /// 资产属性
        /// </summary>
        [MaxLength(64)]
        public string Asset_attribute { get; set; }

        /// <summary>
        /// 物料类型描述
        /// </summary>
        [MaxLength(255)]
        public string Material_type_desc { get; set; }

        /// <summary>
        /// 工厂
        /// </summary>
        [MaxLength(128)]
        public string Factory { get; set; }

        /// <summary>
        /// 采购组
        /// </summary>
        [MaxLength(64)]
        public string Purchase_grp { get; set; }

        /// <summary>
        /// 采购组名称
        /// </summary>
        [MaxLength(128)]
        public string Group_name { get; set; }

        /// <summary>
        /// 采购单位
        /// </summary>
        [MaxLength(255)]
        public string Purchase_org { get; set; }

        /// <summary>
        /// 发货单位
        /// </summary>
        [MaxLength(255)]
        public string Delivery_company { get; set; }

        /// <summary>
        /// 产品组
        /// </summary>
        [MaxLength(64)]
        public string Product_group { get; set; }

        /// <summary>
        /// 产品组描述
        /// </summary>
        [MaxLength(255)]
        public string Product_group_desc { get; set; }

        /// <summary>
        /// 批次标识
        /// </summary>
        [MaxLength(16)]
        public string Batch_mark { get; set; }

        /// <summary>
        /// 序列号参数文件
        /// </summary>
        [MaxLength(32)]
        public string Serialno_param { get; set; }

        /// <summary>
        /// 质检标识
        /// </summary>
        [MaxLength(255)]
        public string Test_mark { get; set; }

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime? Create_date { get; set; }

        /// <summary>
        /// 上次修改时间
        /// </summary>
        public DateTime? Update_date { get; set; }
    }
}
